SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_AddBulletinEmploymentLecture]
    (
      @JOL_BulletinLecture_Title VARCHAR(50),
      @JOL_BulletinLecture_Speaker VARCHAR(50),
      @JOL_BulletinLecture_Time DATETIME,
      @JOL_BulletinLecture_Position VARCHAR(50),
      @JOL_BulletinLecture_Host VARCHAR(50),
      @JOL_BulletinLecture_Organizer VARCHAR(50),
      @JOL_BulletinLecture_Body NTEXT,
      @JOL_BulletinLecture_Remark NTEXT,
      @JOL_BulletinLecture_AddUser VARCHAR(50),
      --@JOL_BulletinLecture_UpdateTime DATETIME,
      --@JOL_BulletinLecture_UpdateUser VARCHAR(50),
      --@JOL_BulletinLecture_ClickNumber INT,
      @JOL_BulletinLecture_IsSetTop BIT
    )
AS 
    INSERT  INTO dbo.JOL_BulletinEmploymentLecture
            (
              JOL_BulletinLecture_Title,
              JOL_BulletinLecture_Speaker,
              JOL_BulletinLecture_Time,
              JOL_BulletinLecture_Position,
              JOL_BulletinLecture_Host,
              JOL_BulletinLecture_Organizer,
              JOL_BulletinLecture_Body,
              JOL_BulletinLecture_Remark,
              JOL_BulletinLecture_AddTime,
              JOL_BulletinLecture_AddUser,
              JOL_BulletinLecture_UpdateTime,
              JOL_BulletinLecture_UpdateUser,
              JOL_BulletinLecture_ClickNumber,
              JOL_BulletinLecture_IsSetTop
            )
    VALUES  (
              @JOL_BulletinLecture_Title, -- JOL_BulletinLecture_Title - varchar(50)
              @JOL_BulletinLecture_Speaker, -- JOL_BulletinLecture_Speaker - varchar(50)
              @JOL_BulletinLecture_Time, -- JOL_BulletinLecture_Time - datetime
              @JOL_BulletinLecture_Position, -- JOL_BulletinLecture_Position - varchar(50)
              @JOL_BulletinLecture_Host, -- JOL_BulletinLecture_Host - varchar(50)
              @JOL_BulletinLecture_Organizer, -- JOL_BulletinLecture_Organizer - varchar(50)
              @JOL_BulletinLecture_Body, -- JOL_BulletinLecture_Body - ntext
              @JOL_BulletinLecture_Remark, -- JOL_BulletinLecture_Remark - ntext
              GETDATE(), -- JOL_BulletinLecture_AddTime - datetime
              @JOL_BulletinLecture_AddUser, -- JOL_BulletinLecture_AddUser - varchar(50)
              NULL, -- JOL_BulletinLecture_UpdateTime - datetime
              '', -- JOL_BulletinLecture_UpdateUser - varchar(50)
              0, -- JOL_BulletinLecture_ClickNumber - int
              0  -- JOL_BulletinLecture_IsSetTop - bit
            )

GO
